package com.tjetc.dao;

import com.tjetc.domain.Room;
import com.tjetc.utils.PageInfo;

import java.sql.SQLException;
import java.util.List;

public interface RoomDao {
    int getCount(String number) throws SQLException;

    List<Room> list(String number, PageInfo<Room> pageInfo) throws SQLException;

    Room findByNumber(String number) throws SQLException;

    int add(Room room) throws SQLException;

    int update(Room room) throws SQLException;

    int del(int id) throws SQLException;

    List<Room> list1() throws SQLException;

    Room findById(int roomid) throws SQLException;
}
